delete from creditnote delete from creditnotelog delete from CashDrawer_Dtl delete from CashDrawer_Log delete from CashDrawer_Mst delete from EndDay_BalancingDtl delete from EndDay_BalancingMst delete from Grn_Dtl delete from Grn_Mst delete from HoldSales_Dtl delete from HoldSales_Mst delete from Payment_Details delete from PettyCash delete from Refund_Detail delete from Refund_Mst delete from Repacking_Detail delete from Repacking_Master delete from Sales_Dtl delete from Sales_Mst delete from Stock_Transactions delete from StockAdjustment_Dtl delete from StockAdjustmentMaster DELETE FROM Sales_Payment_Details DELETE FROM Sales_Payment_MASTER delete from StockIn_Dtl delete from StockIn_Master delete from product_stocklist Update product_master set physical_qty=0